package com.ant.storage.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

import java.math.BigDecimal;

/**
 * @author hzd
 * @version 1.0
 * @date 2023/8/5 9:07
 */
@Data
public class InventoryCensusExecl {

    @ExcelProperty(value = "仓库", index = 0)
    @ColumnWidth(12)
    private String warehouseId;

    @ExcelProperty(value = "编号", index = 1)
    private String commodityBarCode;

    @ExcelProperty(value = "品名规格", index = 2)
    @ColumnWidth(20)
    private String commodityName;

    @ExcelProperty(value = "单位", index = 3)
    private String commodityUnits;

    @ExcelProperty(value = {"上期结存", "数量"}, index = 4)
    private BigDecimal previousPeriodBalanceTotal;

    @ExcelProperty(value = {"上期结存", "金额"}, index = 5)
    private BigDecimal previousPeriodBalanceTotalPrice;

    //本期收入
    @ExcelProperty(value = {"本期收入", "数量"}, index = 6)
    private BigDecimal incomeTotal;

    @ExcelProperty(value = {"本期收入", "金额"}, index = 7)
    private BigDecimal incomeTotalPrice;

    //本期发出
    @ExcelProperty(value = {"本期发出", "数量"}, index = 8)
    private BigDecimal issueTotal;

    @ExcelProperty(value = {"本期发出", "金额"}, index = 9)
    private BigDecimal issueTotalPrice;

    //本期结存
    @ExcelProperty(value = {"本期结存", "数量"}, index = 10)
    private BigDecimal currentPeriodBalanceTotal;

    @ExcelProperty(value = {"本期结存", "金额"}, index = 11)
    private BigDecimal currentPeriodBalanceTotalPrice;


//    @ExcelProperty(value = "仓库", index = 12)
//    @ColumnWidth(12)
//    private Integer commodityId;
//
//    @ExcelProperty(value = "仓库", index = 13)
//    @ColumnWidth(13)
//    private Integer Id;
}
